Release 10.1A: OpenEdge Data Management:
Database Administration

PROMON Resolve 2PC Limbo Transactions option

Lets you resolve a two-phase commit limbo transaction by either committing or aborting the transaction. When you choose this option, PROMON displays the menu shown in Figure 19–55.

1 Abort a Limbo Transaction      2 Commit a Limbo Transaction      Q Quit      Enter choice>

Figure 19–55: Sample output for PROMON Resolve 2PC Limbo Transactions option

Abort a Limbo Transaction

When you choose Abort a Limbo Transaction, PROMON prompts you to enter the user number of the transaction you want to abort. (PROMON displays the user’s number in the User column of the 2PC Transaction Control screen.) Enter the user’s number, then press RETURN.

Commit a Limbo Transaction

When you choose Commit a Limbo Transaction, PROMON prompts you to enter the user number of the transaction you want to commit. (PROMON displays the user number in the Usr column of the 2PC Transaction Control screen.) Enter the user number, then press RETURN. PROMON displays a message similar to the following:

User 1: commit transaction and disconnect.

Note: To commit transactions on a database that is shut down, you must use the 2PHASE RECOVER qualifier of PROUTIL.